Entry Name: Tufte's soldiers-MC1

VAST Challenge 2015
Mini-Challenge 1

Team Members:
- Ivan Itzcovich - iitzcovi@itba.edu.ar
- Iojanan Chervonagura - pchervon@itba.edu.ar
- Kevin Hirschowitz - khirscho@itba.edu.ar
- Matias Domingues - matdomin@itba.edu.ar

Student Team: YES

Did you use data from both mini-challenges? YES

Analytic Tools Used: Postgresql, Tableau, RAW

Approximately how many hours were spent working on this submission in total? 30

May we post your submission in the Visual Analytics Benchmark Repository after VAST Challenge 2015 is complete?

Video:

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Questions

MC1.1 Characterize the attendance at DinoFun World on this weekend. Describe up to twelve different types of groups at the park on this weekend.

a.       How big is this type of group?

b.      Where does this type of group like to go in the park?

c.       How common is this type of group?

d.      What are your other observations about this type of group?

e.      What can you infer about this type of group?

f.        If you were to make one improvement to the park to better meet this group\92s needs, what would it be?

Limit your response to no more than 12 images and 1000 words.

Bodyguards

  1. Group of 8.
  2. They didn't check-in at any attraction and they walk the same path every day, as shown in image (1.1).
  3. Only one group.
  4. Every day they start walking at 8:45 from the right entrance and they get to Grinosaurus Stage at 9:30. At 11:30 they return back to the entrance of the park, where they arrive at 12:15. They repeat the same process at 13:45 to 14:30 and at 16:30 to 17:15. On Sunday, they don’t make the second walk (13:45 to 14:30 and 16:30 to 17:15).
  5. This group corresponds to Scott Jones' bodyguards or Scott’s entourage.
  6. Placing the stage nearer to the Entrance or providing a vehicle to reduce the walking time (45 minutes).

(1.1)

Made in Tableau. This image shows this group movement in the park. Everyday the same path from the entrance to Grinosaurus Stage and all the way back.

Burglars

  1. Group of 48. (See Creighton Pavilion in graphic (1.2) )
  2. They visit Creighton Pavilion on Friday, Saturday and Sunday, where the medals are robbed.
  3. Only one group.
  4. On Sunday, they are at Creighton Pavilion between 11 and 13. According to our observations, the crime was around 12.
  5. This group is considered the principal suspicious beacause they are at the crime scene and in the time when the crime happens, and also because they enter the exhibition everyday.
  6. It's weird to attend 3 days to the same exhibition. Guards should have noticed this behaviour. Normally, no one attends to the same exhibition three times in a row unless something is planning...

(1.2)

Made in Tableau. This image shows the ckeck-ins in every attraction on Sunday from 11 to 13, but only from the people who went all days to the exhibition. With this visualization, we identified this group of 48 "suspicious" who were in Creighton Pavilion.

Big Tour Groups

  1. Several groups consisting of 30 - 45 members each.
  2. Each group moves consistently together, although there is no relation between the activity each group goes.
  3. At least 4 of this groups per day
  4. They follow a time frame, each group checks in at different games but, they seem to check-in at the same time. They access the park between 9:00 - 9:30 and they do not re-visit the park.
  5. We can infer that they have a prepared schedule, and are all related to the same tour company.
  6. The park should provide ways to make the group move more efficiently through the park.

Addicts

  1. Group of 296.
  2. They go to the attractions shown in image (1.4)
  3. Only one group.
  4. Each of them went more than 10 times to the same attraction.
  5. They are the “addicts” of DinoFun World!
  6. Provide more attractions of the same category as these ones.

(1.3)

Made in Tableau. This graphic displays the amount of check-ins in each attraction. The size and color represents how big this attraction was in relation to the amount of check-ins. Based on this, we could find the most popular attractions and ask ourselves if there was a group of people that attends to this popular attraction more than 10 times.

(1.4)

Made in Tableau. This graphic displays the attractions where the "addicts" attended. The size represents how big this attraction was in relation to the amount of check-ins by this people. As we thought, these attractions match with the popular attractions shown in (1.3).

No fans

  1. Group of 176.
  2. They like all attractions but Scott’s shows or Craighton Pavilion (where Scott’s medals and trophies are shown).
  3. Only one group.
  4. They like to go to Thrill Rides and Rides for Everyone (more density in this spots in image (1.5) ).
  5. This group goes to the park because they like attractions and games but not because the park was doing the special event to commemorate Scott Jones.
  6. Make alternative shows or bringing other sports’ ex-players the crowd may be interested meeting or attending to their show.

(1.5)

Made in Tableau. This visualization shows the density of check-ins in the park. Clearly, this group of people was not interested in Jones weekend, as they never entered attractions 63 or 32 (Graunusaurus Stage and Creighton Pavilion).

Wakey-wakey

  1. Group of around 2000.
  2. They love to go to as many attractions as possible, most of them enter the park at 8 and leave at 23.
  3. 3 different groups, each of them at one different entrance.
  4. This group likes to get to the park between 8 and 9 am so as to make the most of their day at the park. (See graphic 1.6)
  5. They like to enjoy the whole day in the park so as to go to every attraction they can, as many times as possible.
  6. The park could open earlier, it would be expected that the waky waky group would like to get in the park even earlier.

Sleepy

  1. Less than 60.
  2. They can’t get into many attractions because it’s late.
  3. 3 different groups. Each one on a different entrance.
  4. This group enter the park between 18 and 20, that is almost when the park closes. (See graphic 1.6)
  5. They don’t like losing time on queues, that’s why they arrive when everybody is leaving.
  6. Close the park later.

(1.6)

Made in Tableau. This visualization shows for each hour the amount of checkins in the 3 entrances. Based on this image, we could observe that most people entered the park early (8 to 10) and almost anybody entered at afternoon (18 to 21). This is why we detected the "wakey-wakey" and "sleepy" groups.

TweetBots

  1. Group of 2 (ids 1278894 - 839736).
  2. They don't have any movements or checkins in the park. This means that they are not in the park or they don't have the tracking device.
  3. It is a very rare group, only 2 in the whole park.
  4. They are constantly sending and receiving messages.
  5. The groups may be programmed bots that send messages to the visitors, telling them trending attractions in the park, discounts, or simple guidance information.

(1.7)

Made in Tableau. This graphic shows quantity of messages sent for each id. Clearly, there were 2 people (or bots) who texted way more than others (id 839736 and 1278894).

Boring or disabled people

  1. Group of 47.
  2. They don't check-in at any attraction but the Entrance.
  3. It’s only one group.
  4. They only enter the park but they didn’t get on any attraction.
  5. They are probably companions, very young kids or old people that cannot get into any attraction.
  6. Make attractions suitable for them.

Inseparable

  1. Group from 2 to 2553 people.
  2. These groups don't have a clear or straight tendence in the park, but all members of the group checked-in at the same time at least 2 times in the same attractions.
  3. Groups from 2 to 44 people decreasing frequency.
  4. All members of one group might have been together because they entered at least 2 times at the same time to the same attractions.
  5. They are probably couples (2 people), families (3 to 10 people) or big tours (group with >10 people).

(1.8)

Made in RAW. This visualization represents the quantity of groups according to the size. Having a group with size X means that each of the X people checked-in at the same time at the same attraction at least 2 times with other member of the group.

(1.9)

Made in Tableau. This visualization shows some of the groups found for "Inseparable". Although each member of one group matched at least 2 times in the same attraction and at the same time with other member of the group, we can observe that they matched many more times than only 2. This means exactly what we tought, that if 2 people checked-in at the same time and at the same attraction twice, they actually matched in much more.

MC1.2 Are there notable differences in the patterns of activity on in the park across the three days? Please describe the notable difference you see.

Limit your response to no more than 3 images and 300 words.

 

The first difference that is visible in (2.3) is the fact that the amount of movement and check-ins increased each day. According to (2.1), one notable difference is that on Friday the park apparently closed their doors earlier than the other two days. There is no pattern of checkins or movements in the park after 20 the first day while the other days people stay in the park up to 23. The most visible differences in patterns of activity are related to the cancellation of Scott’s afternoon show on Sunday. This show (which is two hours long) takes place at 14:30 pm in Granusaurus Stage. Most people in the park went to see Jones and therefore the checkins and movements in the park were reduced until the show was over. But as it can be observed in the visualizations, Sunday afternoon was the exception as the show was totally canceled. This fact permitted people to keep on moving through the park and the checkins rate remained stable and not facing a local minimum as it did happened on Friday and Saturday. It can also be observed that on Sunday from 16 the quantity of checkins is almost the same amount that on Saturday. This fact is peculiar as on Sunday much more people visited the park but it can be mentioned that the crimes may have scared many visitors and they left the park before it was planned. One last thing to mention is that the amount of movement on Sunday between 11 to 14 was the highest of all weekend. Based on our predictions, the crime took place in that time zone, so this increment in movement may have been caused by the chaos that the robbery produced.

(2.1)

Made in Tableau. This visualization shows movement in the park through all day. Each line represents one day (orange for Friday, green for Saturday and blue for Sunday).

(2.2)

Made in Tableau. This visualization shows check-ins in the park through all day. Each line represents one day (orange for Friday, green for Saturday and blue for Sunday).

(2.3)

Made in Tableau. This visualization shows for each hour of each day the sum of check-in and movement.

MC1.3 What anomalies or unusual patterns do you see? Describe no more than 10 anomalies, and prioritize those unusual patterns that you think are most likely to be relevant to the crime.

Limit your response to no more than 10 images and 500 words.

Closed Doors

The park doors seem to be closed between 11:00 - 13:00 and 15:00 - 17:00. Although there are people checking-in at the doors during that times, they are not the first ones, so we can infer that they were already at the park and just happen to be at the location during that time.

Crime Scene

As shown in the image below, on Friday and Saturday the exhibition opens 3 times per day (8-9:30 / 11:30 - 14:30 / 16:30 - 20) having almost the same number of checking per hour. On Sunday (the day of the crime) the second exhibition closes at 12 instead of 14:30 and the third one never opens.

(3.1)

Made in Tableau. The visualization shows the quantity of checkins in Creighton Pavilion every day in the park. As it can be observed, the third day (the day of the crime) the attraction is closed earlier not letting any more checkins.

Show cancelled

On Friday and Saturday there are 2 programmed shows where Scott Jones appears, one of them in the morning (9:30 to 11:30) and the other one in the afternoon (14:30 to 16:30). Due to the fact that crimes have been taking place at the park, the afternoon show that was expected to take place at Grinosaurus Stage on Sunday was cancelled. This can be inferred in the graphic below because there are not checkins at the Stage after 10 am.

(3.2)

Made in Tableau. The sum of checkins in granosaurus stage is shown along the three days. The afternoon show usually has more attendance than the morning one. Thanks to this graph we inferred that the afternoon show in the third day was cancelled as the checkins went down to 0 while the usual amount of them was about 700 and above.

Frightened Bodyguards

Every day they start walking at 8:45 from the right entrance and they get to Granusaurus Stage at 9:30. At 11:30 they return back to the entrance of the park, where they arrive at 12:15. They repeat the same process at 13:45 to 14:30 and at 16:30 to 17:15. On Sunday, they don’t make the second walk (13:45 to 14:30 and 16:30 to 17:15). This can be observed in the graphic below, which shows that the amount of movement on Sunday is more or less the 50% of the amount of movement on the other days.

(3.3)

Made in Tableau. In this visualization shows the movement of each one of the guards for each day. The height of the bars correspong to the amount of measures of their movement.

Suspicious guys

We’ve already included this group in the first part. This 48 guys attended the exhibition in Creighton Pavilion 3 times, that is, on Friday, Saturday and Sunday. We consider this a strange pattern because it’s not common to visit the same exhibition more than one time. Normally, one person sees the trophies and medals for one time and don’t come back to see them again, unless he is planning to do something (like a robbery). This persons could have been analyzing the place, the guards (that by the way are only a few, the park is hiring!) and the best moment to commit the crime.